namespace Delphi.Mimir.Migrations
{
    using System;
    using System.Data.Entity.Migrations;
    
    public partial class AddAltSymCd : DbMigration
    {
        public override void Up()
        {
            AddColumn("fin.eod_symbols", "sym_yahoo_fg", c => c.Boolean());
            AddColumn("fin.eod_symbols", "sym_yahoo_cd", c => c.String(maxLength: 25, unicode: false));
            AddColumn("fin.eod_symbols", "sym_google_fg", c => c.Boolean());
            AddColumn("fin.eod_symbols", "sym_google_cd", c => c.String(maxLength: 25, unicode: false));
            AddColumn("fin.eod_quotes", "qot_adj_factor", c => c.Decimal(precision: 18, scale: 2));
            AddColumn("raw.eod_quotes", "qot_adj_factor", c => c.Decimal(precision: 18, scale: 2));
        }
        
        public override void Down()
        {
            DropColumn("raw.eod_quotes", "qot_adj_factor");
            DropColumn("fin.eod_quotes", "qot_adj_factor");
            DropColumn("fin.eod_symbols", "sym_google_cd");
            DropColumn("fin.eod_symbols", "sym_google_fg");
            DropColumn("fin.eod_symbols", "sym_yahoo_cd");
            DropColumn("fin.eod_symbols", "sym_yahoo_fg");
        }
    }
}
